Menu Price file Import

Introduction

This is generic menu price file import for any manufacturer. This will import vehicle file to Cloud SQL for PostgreSQL

Applicable Manufacturers

• KIA

Fields

Field Name	Description	Datatype	Validation	Max length	Mandatory	Example
Model	Model	String	A-Z and 0-9	20	Y	0TW5K9A1TEV1DD085
ModelYr	Model Year	Numeric	0-9	4	Y	2023
Product	Repair Short Desc	String	A-Z	20	Y	SERVICING
Job Description	Repair Desc 1	String	A-Z, 0-9 & All Special Characters	100	Y	SERVICE 10,000 or 12 MONTHS
Job Variant	Repair Desc 2	String	A-Z, 0-9 & All Special Characters	100	Y	Standard
Lab Hours	Labour Time	Number	Up to 2 decimals	4	Y	0.9
Part No	Part Number	String	A-Z, 0-9 & All Special Characters	50	Y	2151323001
Part Description	Part Name	String	A-Z, 0-9 & All Special Characters	100	Y	Sump Plug Washer
IsFluid	A column to differentiate between parts and fluids 0 is FALSE -1 is TRUE	String	Allows -1 and 0	2	Y	-1
Unit Price	Part Price	Number	Up to 2 decimals	7	Y	1.5
Quantity	Part/Fluid qty	Number	Up to 2 decimals	5	Y	1

Note: If there are more columns in the csv, those will be ignored

Importing a file

Preparation

1. Upload the file with filename as menu_price.csv into fnp-imports/{manufacturer}}(E.g. fnp-imports/kia) storage bucket

Validation

Through Cloud Scheduler

1. Go to Cloud Scheduler
2. Run manufacturer_menu_price_validation job (job name could be different on other env)

Local

1. Add the menu_price.csv file in importFiles folder
2. Run npm run validate:menu-price can control the number of lines to validate using -l(number of lines), -s (start line) and -m (manufacturer)arguments

Importing

Through Cloud Scheduler

1. Go to Cloud Scheduler
2. Run manufacturer_menu_price_import job (job name could be different on other env)

Local

Same as Validation, just the command is npm run import:menu-price

Testing

1. Data will be inserted to Cloud SQL for PostgreSQL under fpn database in table menu_price.

Status: Accepted
Category: Protected
Authored By: Gladson on Feb 07, 2025

Revisions